<h1 class="top">Distinct</h1>
<h2>The block</h2>
<img src="help/img/distinct.png" alt="Distinct Blog" class="leftFloatIMG">
<p class="leftFloat left">
  This block symbolises the distinct clause. 
  Sometimes a column can contain many duplicate values.
  If you want to list only the different values, you use distinct. 
  It is used as a value in the "SELECT"-section and in some of the 
  <span class="groupLinks pointer" onclick="fetchthelink('Help/groupfunction/avg.html','#63a65a')">groupfunctions</span>.
  The block changes also the colour to represent <a href="#types" class="groupLinks">types</a>.
</p>
<h2> Functionality</h2>
<img src="help/img/distinct_function.png" alt="distinct" class="img"> 
<p class="text" style="margin-top: 0px;">
    As you see in  the picture on the right, 
    this block is used with one table and column block. 
    Notice that there can be only one table and column block for each distinct clause.</p>
<h2 id="types">The types</h2>
<img src="help/img/distinct_list.png" alt="Type bool" class="img" style="margin-top: 10px;">
<p class="text"> This colour ,apple green, symbolises list, like all selected columns.</p>
<img src="help/img/distinct_int.png" alt="Type numeric" class="img" style="margin-top: 10px;">
<p class="text"> This colour,violet,  symbolises the numeric values of the database</p>
<img src="help/img/distinct_text.png" alt="Type text" class="img">
<p class="text"> This colour, brown, symbolises the textual values of the database</p>
<img src="help/img/distinct_date.png" alt="Type date" class="img">
<p class="text"> This colour,tapestry, symbolises the date values of the database</p>
<img src="help/img/distinct_bool.png" alt="Type bool" class="img">
<p class="text"> This colour ,cyan, symbolises the boolean values of the database</p>
<div id="aliasback"></div>